package com.tedu._04mybatis.mapper;

import com.tedu._04mybatis.pojo.*;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface WeiboMapper {

    /*
    @Insert("INSERT INTO weibo(content,created,user_id) " +
            "VALUES (#{content},#{created},#{userId}) ")
     */

    int insert(Weibo weibo);

    /*
     @Delete("DELETE FROM weibo " +
            "WHERE id=#{id} ")
     */

    int deleteWeiboById(Integer id);


    /*
    @Update("UPDATE weibo " +
            "SET content=#{content},created=#{created},user_id=#{userId} " +
            "WHERE id=#{id} ")
     */

    int updateWeibo(Weibo weibo);

    /*
    @Select("SELECT id,content,created,user_id AS userId " +
            "FROM weibo " +
            "WHERE id=#{id}")
     */

    Weibo selectWeiboById(Integer id);

    /*
    @Select("SELECT id,content,created,user_id AS userId " +
            "FROM weibo")
     */

    List<Weibo> selectAllWeibos();

    /*
     @Select("SELECT content,created " +
            "FROM weibo " +
            "WHERE id=#{id}")
     */

    WeiboVO1 selectWeiboVO1ById(Integer id);

    /*
    @Select("SELECT content,created,user_id AS userId " +
            "FROM weibo ")
     */

    List<WeiboVO2> selectWeiboVO2ById();



}
